<cfcomponent output="false">
	
	<!--- --->
	
	<cffunction name="getSuffixes" access="public" output="false" returntype="query">

		<cfset var local = {} />
		
		<cfquery name="local.getSuffixes" datasource="fundrdb" cachedwithin="#createTimespan(0,1,0,0)#">
			select id,name from suffix where active = 1
		</cfquery>
		
		<cfreturn local.getSuffixes />
		
	</cffunction>
	
	<!--- --->
	
	<cffunction name="getPrefixes" access="public" output="false" returntype="query">

		<cfset var local = {} />
		
		<cfquery name="local.getPrefixes" datasource="fundrdb" cachedwithin="#createTimespan(0,1,0,0)#">
			select id,name from prefix where active = 1
		</cfquery>
		
		<cfreturn local.getPrefixes />
		
	</cffunction>
	
	<!--- --->
	
	<cffunction name="getStates" access="public" output="false" returntype="query">
		<cfargument name="name" required="false" default="" />
		
		<cfset var local = {} />
		
		<cfquery name="local.getStates" datasource="fundrdb" cachedwithin="#createTimespan(0,1,0,0)#">
			select id,abbrev as name 
			from state
			<cfif structKEyExists(arguments,"name") and arguments.name neq "">
				where name = '#arguments.name#'
			</cfif>
		</cfquery>
		
		<cfreturn local.getStates />
		
	</cffunction>
	
	<!--- --->

</cfcomponent>